IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'ChapterUpdate')
	BEGIN
		DROP  Procedure  ChapterUpdate
	END

GO

CREATE Procedure ChapterUpdate
@ChapterID Int,
@Title Varchar(500),
@Header Ntext,
@Footer Ntext,
@StartMonth Int,
@StartYear Int,
@EndMonth Int,
@EndYear Int,
@OwnerID Int,
@ViewOrder Int,
@AccessType Int,
@IsPrivate bit
AS
Update Chapter 

	Set Title = @Title,
	Header = @Header,
	Footer = @Footer,
	StartMonth = @StartMonth,
	StartYear = @StartYear,
	EndMonth = @EndMonth,
	EndYear = @EndYear,
	OwnerID = @OwnerID,
	ViewOrder = @ViewOrder,
	AccessType = @AccessType,
	IsPrivate = @IsPrivate,
	LastUpdated = GetDate()

Where ChapterID = @ChapterID



GO

